在MySQL 5.5 後可以使用 PARTITION BY RANGE COLUMNS(created_date) 解決這個問題。 Rotate Partition. 在經過一段時間後，我們需要更動分區表，類似新增 ... ... <看更多>

MySQL: How avoid all partitions scan (year-based) when doing ID lookup? mysql partitioning pruning. In case I have a table partitioned by year; ... ... <看更多>

This type of partitioning is similar to partitioning by HASH, except that only one or more columns to be evaluated are supplied, and the MySQL server provides ... ... <看更多>

"The rule is : All columns used in the partitioning expression for a partitioned table must be part of every unique key that the table may have. ... <看更多>

... <看更多>